Social Data Analysis and Visualization - Assignment 2¶

Introduction¶

Vandalism is damage to public or private property. It has been a serious problem in San Francisco for a long time. For example, graffiti on walls in the Mission District and broken windows in SOMA cost the city large sums of money each year. They also reduce the sense of safety in local neighborhoods. Police data from 2003 to 2024 show that vandalism in San Francisco may have changed with local policy shifts and community efforts.

In 2006, then-Mayor Gavin Newsom started the “Graffiti Watch” program[1]. It asked residents to report graffiti incidents and restore damaged public spaces. In 2015, reports of serious vandalism such as broken car windows went up. Then, law enforcement targeted repeat offenders[2][3]. But these actions were not the same across all areas. Some grassroots groups and neighborhood coalitions also formed. They tried to involve young people and create mural projects that turned graffiti into approved street art.

In 2018, the city introduced stricter rules. They required property owners to remove graffiti within 48 hours or pay fines[4]. Some people say this led to a quick rise in recorded vandalism because more cases were reported. Others believe large events and more tech workers influenced these changes. During the COVID-19 pandemic in 2021–2022, certain kinds of vandalism, went up in some districts[5].

These social and policy factors guide our data exploration. For this project, we use crime reports from 2003 to 2024 to answer key questions:

  • When does vandalism happen most often (by hour, day, or season)?
  • Where are the main hotspots, and how have they shifted over time?
  • Did policy changes or community efforts affect vandalism rates?

Our analysis has three main visual displays:

  • A time-series chart to show hourly and weekday trends,
  • A heatmap to show month-to-month changes,
  • An interactive Bokeh chart that lets readers explore district-level patterns by year.

A Short Data Story: Trends in Vandalism over time across the SF Police Districts¶

No description has been provided for this image

Figure 1: The above time series chart shows the number of Vandalism crime occurences in SF at each hour of the day for all days of the week. It can be observed that during early morning (4am-6am), the numbers are the lowest and it keeps rising and the daytime peak is at 12 pm for all the days. There is a little dip after that and then it again keeps increasing to reach the highest peak at 6pm. Throughout the evenings, the numbers remain high and stop dropping steadily after midnight. Friday evenings, Saturdays and Sundays have generally higher occurences than workdays. This observation is consistent with research[6] and this might be linked to more public gatherings or nightlife on weekends.

Make this Notebook Trusted to load map: File -> Trust Notebook

Figure 2: The above movie shows Vandalism occurences in SF for each month across all the years (2003-2024). Northern, IngleSide and Mission appear to be the hotspots over the years, recording high numbers throughout. Taraval, Richmond and Park have had relatively low number of occuurences. After 2017, activities have increased in districts like Mission, Tenderloin and Central. The overall number of cases across the different districts seem to have increases in recent years. This observation is consistent with research[7]. The map suggests that hotspots can shift over time, perhaps because of gentrification, better security, or community programs.

Loading BokehJS ...

Figure 3: The above interactive vizualization shows the normalized Vandalism occurences for each month of the year. The Y-axis represents the relative frequency of occurences. The bars show monthly variations in Vandalism for each SF district. The line plots for each year show monthly trends for that year, irrespective of districts.

It can be observed that districts like Ingleside, Mission, Northern have recorded higher occurences than other SF districts. Southern, Bayview, Central have had comparitively low counts. The line plots show that for some years summer months have recorded higher counts than winters. 2009 and 2011 have had quite high counts in December. 2017 had higher counts in July-August than most other years.This observation is consistent with research[8].

Analysing Vandalism Trends over time across SF Districts¶

We have studied temporal patterns in SF's Vandalism crimes through a time-series plot showing hourly occurences across each day of the week (Figure 1), a heatmap movie (Figure 2) to depict the trends in incidents for each month over the years and an interactive plot to show monthy occurences in each SF district over the years (Figure 3).

From analysing these plots we have observed that districts like Mission, Northern and Ingleside are Vandalism hotspots whereas, Southern, Bay, Central have had consistently lower occurences. In recent years, cases have increased in Mission, Tenderloin and Central districts, making them relatively safer in terms of Vandalism crimes. Increased activities from Friday afternoon, till Sunday night is expected and could be accounted for by increase in night-life, alcohol and substance use, and lower surveillance since business and offices are closed. Intoxication is a very likely reason for younger groups of people hanging out during weekends to vandalise property, either due to personal spite or purely for fun. During daytime, visibility is high and group activities like parties, gatherings, substance consumption etc is low, coupled with higher police patrolling leading to reduced activities during office hours.

Conclusion¶

The analysis shows that vandalism in San Francisco depends on both time and place. We see higher incidents on weekends and during evening hours. We also find hotspots that stay active for many years. Some neighborhoods report high activity, but others show improvement over time.

These patterns can guide policymakers, law enforcement, and local communities on where and when to act. They can add more surveillance, hold public awareness events, or improve street lighting. This data makes it easier to build safer neighborhoods and meet community needs.

References¶

[1] San Francisco Public Works. Annual Report 2007–2008[EB/OL]. [2008]. Available: https://sfpublicworks.org/sites/default/files/90_AnnualRpt_0209.pdf [2] "S.F. car break-ins up 31 percent, nearly triple in 5 years"[EB/OL]. SFGATE, 2016-03-15. Available: https://www.sfgate.com/crime/article/S-F-car-break-ins-up-31-percent-nearly-triple-6894503.php?utm_source=chatgpt.com

[3] "Why Can't San Francisco Stop Its Epidemic of Window Smashing?"[EB/OL]. The Atlantic, 2016-04-12. Available: https://www.theatlantic.com/politics/archive/2016/04/san-francisco-crime-policy/479880/?utm_source=chatgpt.com

[4] San Francisco Public Works Code, Article 23: Graffiti Removal and Abatement[EB/OL]. Available: https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_publicworks/0-0-0-4912?utm_source=chatgpt.com

[5] "Vandals Adding To Struggling San Francisco Chinatown Businesses COVID Recovery Woes"[EB/OL]. CBS San Francisco, 2021-06-14. Available: https://www.cbsnews.com/sanfrancisco/news/san-francisco-chinatown-vandals-businesses-covid-recovery-woes/?utm_source=chatgpt.com

[6] San Francisco Police Department. (n.d.). Crime Dashboard. https://www.sanfranciscopolice.org/stay-safe/crime-data/crime-dashboard

[7] San Francisco Government. Street and Sidewalk Standards Annual Report Fiscal Year 2024[EB/OL]. [2024-12-04]. Available: https://www.sf.gov/reports--december-2024--street-and-sidewalk-standards-annual-report-fiscal-year-2024.

[8] San Francisco Chronicle. (2024, January 5). San Francisco violent, property crime fell to 20-year low in 2024. https://www.sfchronicle.com/crime/article/san-francisco-2024-data-20020378.php

Contibutions¶

Srijita Sarkar (s242527) - SS¶
Zhanhui Qu (s242603) - ZQ¶
Aikaterini Laskaraki (s242809) - KL¶
SS ZQ KL
Plots and Figure Captions 80% 10% 10%
Creating the Website 10% 10% 80%
Introduction and Conclusion 10% 80% 10%